package com.pan.kang.model.cons;

import com.pan.kang.support.SqlResource;

import java.util.HashMap;
import java.util.Map;

public final class AccComprehensiveQueryDaoConst {
    private static final String SQL_CLASS = AccComprehensiveQueryDaoConst.class.getName();
    public static final String TABLE_QT_ZW_WDBILLMX = "ACC_QT_DIM_VOU_DTL";
    public static final String TABLE_GT_ZW_WDBILLMX = "GT_ZW_WDBILLMX";
    public static final String TABLE_ACC_BAL_DIM_ROW = "ACC_BAL_DIM_ROW{1}";
    public static final String TABLE_ACC_BAL_DIM_ROW_TOP = "ACC_BAL_DIM_ROW{1}_TOP";
    public static final String TABLE_ACC_BAL_DIM_SUM = "ACC_BAL_DIM_SUM{1}";
    public static final String ACC_BAL_STA_DIM_SUM = "ACC_BAL_STA_DIM_SUM{1}";
    public static final String TABLE_ACC_BAL_DIM_SUM_TOP = "ACC_BAL_DIM_SUM{1}_TOP";
    public static final String ACC_BAL_STA_DIM_SUM_TOP = "ACC_BAL_STA_DIM_SUM{1}_TOP";
    public static final String TABLE_ACC_BAL_SUM = "ACC_BAL_SUM{1}";
    public static final String TABLE_ACC_BAL_SUM_TOP = "ACC_BAL_SUM{1}_TOP";
    public static final String TABLE_OSET_BAL_CLCT = "OSET_BAL_CLCT{1}";
    public static final String TABLE_OSET_SUM_TOP = "OSET_BAL_SUM{1}_TOP";
    public static final String TABLE_OSET_SUM = "OSET_BAL_SUM{1}";
    public static final String TABLE_OSET_BAL_DIM_SUM_TOP = "OSET_BAL_DIM_SUM{1}_TOP";
    public static final String TABLE_OSET_BAL_SUM_TOP = "OSET_BAL_SUM{1}_TOP";
    public static final String TABLE_OSET_BAL_SUM = "OSET_BAL_SUM{1}";
    public static final String TABLE_OSET_BAL_DIM_SUM = "OSET_BAL_DIM_SUM{1}";
    public static final String TABLE_OSET_BAL_DIM_ROW_TOP = "OSET_BAL_DIM_ROW{1}_TOP";
    public static final String TABLE_OSET_BAL_DIM_ROW = "OSET_BAL_DIM_ROW{1}";
    public static final String TABLE_OSET_BAL_DIM_ROW_CLCT = "OSET_BAL_DIM_ROW_CLCT{1}";
    public static final String TABLE_OSET_BAL_DIM_CLCT = "OSET_BAL_DIM_CLCT{1}";
    public static final Map<String, String> DATATYPE_ENUM = new HashMap();
    public static final Map<String, String> DATATYPE_ENUM_KM;
    public static final Map<String, String> DATATYPE_ENUM_SUM;
    public static final Map<String, String> DATATYPE_ENUM_KM_FOR_WD;
    public static final String F_AND = " AND ";
    public static final String F_UNION = " UNION ";
    public static final String F_UNION_ALL = " UNION ALL ";
    public static final String SQL_GET_ENDACCOUNT_ENDTIME;
    public static final String SQL_GET_ACCOUNT_RANGE;
    public static final String SQL_QUERY_GETWDDY;
    public static final String SQL_QUERY_GETXTSSZDS;
    public static final String SQL_QUERY_GETXTSSZD;
    public static final String FIND_KM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_KM_HZ_INFO_FOR_ONE_MONTH;
    public static final String FIND_KM_HZ_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_KM_HZ_INFO_FOR_MONTH;
    public static final String FIND_KM_HZ_INFO_BY_MONTH;
    public static final String FIND_KM_HZ_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_KM_HZ_INFO_BY_QUARTER;
    public static final String FIND_KM_HZ_INFO_BY_QUARTER_FOR_CUR;
    public static final String FIND_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_ONE_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_DIM_HZ_INFO_FOR_ONE_MONTH;
    public static final String FIND_ONE_DIM_HZ_INFO_FOR_ONE_MONTH;
    public static final String FIND_DIM_HZ_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_ONE_DIM_HZ_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_DIM_HZ_INFO_FOR_MONTH;
    public static final String FIND_ONE_DIM_HZ_INFO_FOR_MONTH;
    public static final String FIND_DIM_HZ_INFO_BY_MONTH;
    public static final String FIND_ONE_DIM_HZ_INFO_BY_MONTH;
    public static final String FIND_DIM_HZ_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_ONE_DIM_HZ_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_DIM_HZ_INFO_BY_QUARTER;
    public static final String FIND_ONE_DIM_HZ_INFO_BY_QUARTER;
    public static final String FIND_DIM_HZ_INFO_BY_QUARTER_FOR_CUR;
    public static final String FIND_ONE_DIM_HZ_INFO_BY_QUARTER_FOR_CUR;
    public static final String FIND_KM_HB_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_KM_HB_INFO_FOR_ONE_MONTH;
    public static final String FIND_KM_HB_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_KM_HB_INFO_FOR_MONTH;
    public static final String FIND_KM_HB_INFO_BY_MONTH;
    public static final String FIND_KM_HB_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_KM_HB_INFO_BY_QUARTER;
    public static final String FIND_KM_HB_INFO_BY_QUARTER_FOR_CUR;
    public static final String FIND_DIM_HB_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_DIM_HB_INFO_FOR_ONE_MONTH;
    public static final String FIND_DIM_HB_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_DIM_HB_INFO_FOR_MONTH;
    public static final String FIND_DIM_HB_INFO_BY_MONTH;
    public static final String FIND_DIM_HB_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_DIM_HB_INFO_BY_QUARTER;
    public static final String FIND_DIM_HB_INFO_BY_QUARTER_FOR_CUR;
    public static final String FIND_ONE_DIM_HB_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_ONE_DIM_HB_INFO_FOR_ONE_MONTH;
    public static final String FIND_ONE_DIM_HB_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_ONE_DIM_HB_INFO_FOR_MONTH;
    public static final String FIND_ONE_DIM_HB_INFO_BY_MONTH;
    public static final String FIND_ONE_DIM_HB_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_ONE_DIM_HB_INFO_BY_QUARTER;
    public static final String FIND_ONE_DIM_HB_INFO_BY_QUARTER_FOR_CUR;
    public static final String FIND_KM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_KM_OSET_INFO_FOR_ONE_MONTH;
    public static final String FIND_KM_OSET_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_KM_OSET_INFO_FOR_MONTH;
    public static final String FIND_KM_OSET_INFO_BY_MONTH;
    public static final String FIND_KM_OSET_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_KM_OSET_INFO_BY_QUARTER;
    public static final String FIND_KM_OSET_INFO_BY_QUARTER_FOR_CUR;
    public static final String FIND_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_DIM_OSET_INFO_FOR_ONE_MONTH;
    public static final String FIND_DIM_OSET_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_DIM_OSET_INFO_FOR_MONTH;
    public static final String FIND_DIM_OSET_INFO_BY_MONTH;
    public static final String FIND_DIM_OSET_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_DIM_OSET_INFO_BY_QUARTER;
    public static final String FIND_DIM_OSET_INFO_BY_QUARTER_FOR_CUR;
    public static final String FIND_ONE_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_ONE_DIM_OSET_INFO_FOR_ONE_MONTH;
    public static final String FIND_ONE_DIM_OSET_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_ONE_DIM_OSET_INFO_FOR_MONTH;
    public static final String FIND_ONE_DIM_OSET_INFO_BY_MONTH;
    public static final String FIND_ONE_DIM_OSET_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_ONE_DIM_OSET_INFO_BY_QUARTER;
    public static final String FIND_ONE_DIM_OSET_INFO_BY_QUARTER_FOR_CUR;
    public static final String COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM_CLS;
    public static final String COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM_CLS_FOR_CUR;
    public static final String COL_FOR_ROW_HZ_TEMP_CQUERY;
    public static final String COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM;
    public static final String COL_FOR_ROW_HZ_TEMP_CQUERY_FOR_CUR;
    public static final String COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM_FOR_CUR;
    public static final String NOCOL_FOR_ROW_HZ_TEMP_CQUERY;
    public static final String NOCOL_FOR_ROW_HZ_TEMP_CQUERY_FOR_CUR;
    public static final String INSERT_RESULT_IN_HZ_TEMP_ONE_DIM;
    public static final String INSERT_RESULT_IN_HZ_TEMP_ONE_DIM_FOR_CUR;
    public static final String FIND_KM_SHOW_DIM_INFO;
    public static final String FIND_COMP_P_COMP_ID;
    public static final String FIND_BOTTOM_COMP;
    public static final String DW_KM_HZ_TREE_QUERY;
    public static final String DW_KM_HZ_TREE_QUERY_FOR_CUR;
    public static final String DW_KM_HZ_TREE_QUERY_NO_DIM;
    public static final String DW_KM_HZ_TREE_QUERY_FOR_CUR_NO_DIM;
    public static final String DW_KM_HZ_TREE_QUERY_ONLY_DIM;
    public static final String DW_KM_HZ_TREE_QUERY_ONLY_DIM_FOR_CUR;
    public static final String DW_KM_OBJECT_HZ_TREE_QUERY;
    public static final String DW_KM_OBJECT_HZ_TREE_QUERY_FOR_CUR;
    public static final String DW_KM_BUS_CLASS_HZ_TREE_QUERY;
    public static final String DW_KM_BUS_CLASS_HZ_TREE_QUERY_FOR_CUR;
    public static final String QUERY_RESULT_INTO_QT_TABLE;
    public static final String QUERY_RESULT_INTO_QT_TABLE_FOR_CUR;
    public static final String QUERY_RESULT_FROM_QT_TABLE;
    public static final String QUERY_RESULT_FROM_QT_TABLE_FOR_CUR;
    public static final String SQL_LIST_YWFL_ID_NAME;
    public static final String SQL_LIST_KM_ID_BY_ITEM_CODE;
    public static final String SQL_NO_SHOW_STOPED_KM = " AND A.STOPED = 0 ";
    public static final String SQL_NO_SHOW_STOPED_KM_MYSQL = " AND A.STOPED = 0 ";
    public static final String BUILD_KM_TREE;
    public static final String BUILD_ACCOUNT_ID;
    public static final String RETUEN_ACCOUNT_ID;
    public static final String RETUEN_MONEY_TYPE;
    public static final String RETUEN_MONEY_TYPE_FOR_CUR;
    public static final String BUILD_KM_LEAF_FOR_DIM;
    public static final String RETUEN_ACCOUNT_ID_MONEY_TYPE;
    public static final String BUILD_COMP;
    public static final String RETURN_COMP;
    public static final String RETURN_COMP_MONEY_TYPE;
    public static final String RETURN_COMP_ACCOUNT_MONEY_TYPE;
    public static final String RETURN_COMP_ACCOUNT;
    public static final String BUILD_COMP_ACCOUNT;
    public static final String BUILD_KM_LEAF;
    public static final String RETURN_KM_LEAF;
    public static final String BUILD_KM_LEAF_ACCOUNT;
    public static final String RETURN_KM_LEAF_ACCOUNT;
    public static final String BUILD_KM_LEAF_COMP_ACCOUNT;
    public static final String RETURN_KM_LEAF_COMP_ACCOUNT;
    public static final String BUILD_KM_LEAF_COMP;
    public static final String RETURN_KM_LEAF_COMP;
    public static final String BUILD_COMP_EXPORT;
    public static final String RETURN_COMP_EXPORT;
    public static final String RETURN_COMP_MONEY_TYPE_EXPORT;
    public static final String BUILD_COMP_ACCOUNT_EXPORT;
    public static final String RETURN_COMP_ACCOUNT_EXPORT;
    public static final String RETURN_COMP_ACCOUNT_MONEY_TYPE_EXPORT;
    public static final String BUILD_KM_LEAF_COMP_EXPORT;
    public static final String BUILD_KM_LEAF_COMP_ACCOUNT_EXPORT;
    public static final String DW_FL_TREE_RELATION;
    public static final String FL_FIND_ITEMCODE;
    public static final String SQL_INS_COMPS_QUERY;
    public static final String SQL_LIST_YWFL_ITEMCODE_NAME;
    public static final String SQL_LIST_YWFL_ITEMCODE;
    public static final String SQL_LIST_DXFL_ID_NAME;
    public static final String SQL_LIST_ENUM_ID_NAME;
    public static final String SQL_LIST_KM_ID_NAME;
    public static final String SQL_DO_NOT_BLANK_WD;
    public static final String SQL_GET_NOT_BLANK_WD;
    public static final String DW_TRUN_COMP_SES_SQL_TABLE = "GT_COMPANYINFO_SES";
    public static final String GET_ANALYZECOMPANYINFO_SQL_DEFAULT;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH_FOR_CUR_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH_FOR_CUR_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER_FOR_CUR_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH_FOR_CUR_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH_FOR_CUR_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER_FOR_CUR_SHOW_EMPTY;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER;
    public static final String FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER_FOR_CUR;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH_FOR_CUR;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH_FOR_CUR;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER;
    public static final String FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER_FOR_CUR;
    public static final String SHOW_ALL_DIM_FOR_TEMP_CQUERY;
    public static final String SHOW_ALL_DIM_FOR_TEMP_CQUERY_FOR_CUR;
    public static final String FIND_DIM_FROM_DIM_GROUP;
    public static final String SHOW_ALL_DIM_FOR_COL;
    public static final String SHOW_ALL_DIM_INTO_TEMP;
    public static final String SHOW_ALL_DIM_INTO_TEMP_FOR_CUR;
    public static final String DELETE_SHOW_ALL_DIM_BZXZ_0;
    public static final String MER_JAN_DATA_TO_GT_ZW_WDBILLMX;
    public static final String YW_MAIN_DATA_GROUP_TO_GT_ZW_WDBILLMX2;
    public static final String INSERT_YW_MAIN_DATA_GROUP_TO_GT_ZW_WDBILLMX;
    public static final String OPEN_LOG;
    public static final String CLOSE_LOG;
    public static final String CLEAR_LOG;
    public static final String FIND_LOG;
    public static final String ACC_VOUCH_KM_QUERY_SQL = "SELECT SUM(B.STD_CUR_AMT) JE, B.LOAN_SIGN , B.ACC_SUB FROM ACC_VOUCH[YEAR] A INNER JOIN ACC_VOUCH_DTL[YEAR] B ON A.BILL_ID = B.BILL_ID INNER JOIN HZ_COMPID_TREE C ON C.COMPID = B.FINA_ORG INNER JOIN GT_ZW_WDBILLMX2 D ON B.ACC_SUB = D.KMID WHERE A.FINISH_SUM_FLAG = 1 AND B.ACC_BOOK = :ACCBOOK AND A.ACCO_STATUS = :ACCOSTATUS AND  ([TIMESQL])  GROUP BY B.ACC_SUB, B.LOAN_SIGN";
    public static final String ACC_VOUCH_KM_WD_QUERY_SQL = "SELECT  B.ACC_SUB,  SUM(B.STD_CUR_AMT) JE,  B.LOAN_SIGN  [WDCOL]  FROM ACC_VOUCH[YEAR] A  INNER JOIN ACC_VOUCH_DTL_DIM[YEAR] B  ON A.BILL_ID  = B.BILL_ID  INNER JOIN HZ_COMPID_TREE C  ON C.COMPID = B.FINA_ORG  INNER JOIN GT_KMSRCTAB D  ON B.ACC_SUB = D.IID  WHERE  A.FINISH_SUM_FLAG = 1  AND B.ACC_BOOK = :ACCBOOK  AND A.ACCO_STATUS = :ACCOSTATUS  AND ([TIMESQL]) [CONDITIONWDCOL]  GROUP BY B.ACC_SUB,B.LOAN_SIGN [WDCOL] ";
    public static final String ACC_QT_DIM_VOU_DTL_QUERY_SQL = "SELECT  ACC_SUB accSub, BEGIN_DIRECTION qcfx, BEGIN_REMAINING_STANDARD qcye, CRTR_AMT jfje, CR_AMT dfje, END_REMAINING_STANDARD qmye FROM ACC_QT_DIM_VOU_DTL WHERE KEY_VALUE={0}";
    public static final String ACC_QT_DIM_VOU_DTL_WD_QUERY_SQL = "SELECT  ACC_SUB accSub, BEGIN_DIRECTION qcfx, BEGIN_REMAINING_STANDARD qcye, CRTR_AMT jfje,  CR_AMT dfje, END_REMAINING_STANDARD qmye [WDCOL] FROM ACC_QT_DIM_VOU_DTL WHERE KEY_VALUE={0}";
    public static final String ACC_QT_DIM_VOU_DTL_UPDATE_SQL = " UPDATE ACC_QT_DIM_VOU_DTL SET BEGIN_REMAINING_STANDARD = ? , CRTR_AMT = ? , CR_AMT = ? ,  END_REMAINING_STANDARD = ?  WHERE KEY_VALUE = ? AND ACC_SUB = ? ";
    public static final String ACC_QT_DIM_VOU_DTL_DIM_UPDATE_SQL = " UPDATE ACC_QT_DIM_VOU_DTL SET BEGIN_REMAINING_STANDARD = ? , CRTR_AMT = ? , CR_AMT = ? ,  END_REMAINING_STANDARD = ?  WHERE KEY_VALUE = ? AND ACC_SUB = ?  [CONDITIONWDCOL] ";
    public static final String INSERT_ALLKM;
    public static final String QUERY_KM;
    public static final String DW_KM_HZ_QUERY_ALL_KM = "SELECT {7} FROM (SELECT {6} FROM (\nSELECT\n\t{5} ACCOUNT_ID,{2} TYEAR,:KEY_VALUE KEY_VALUE ,A.ITEM_CODE KMITEMCODE,A.ACCO_CODE KMCODE,A.SUB_FNAME KMMC,A.IS_BOTT_LAY LEAF,A.ACCO_LEVEL ITEMLEVEL,A.ACC_SUB KMID,CASE A.IS_BOTT_LAY WHEN 1 THEN 0 ELSE 1 END ISKMDATA,A.IS_STOPED STOPED,'0' SUMMARY{11}\nFROM ACC_SUBJECT_EXT A,ACC_COMP_SCENE B\nWHERE A.ACC_BOOK = {1} AND A.FISC_YEA = {2} AND A.FINA_ORG = {8} {4}  AND A.ITEM_CODE IN ( SELECT ITEMCODE FROM GT_KMDESTTAB GROUP BY ITEMCODE)\n\tAND B.ORG_SCE_ID = ( SELECT ORG_SCE_ID FROM ACC_BOOK WHERE ACC_BOOK = {1} ) AND B.FINA_ORG {3} AND B.FISC_YEA = {2} {12}) A\nLEFT JOIN ({0}) B ON B.KMITEMCODE = A.KMITEMCODE {9}) A  ORDER BY {10} A.ACCOUNT_ID,A.KMCODE,A.ITEMLEVEL";
    public static final String DW_KM_HZ_QUERY_ALL_KM_CY = "(SELECT {0}\nFROM\n(SELECT\n\t\tA.ITEM_CODE , A.ACCO_CODE , A.SUB_FNAME , A.IS_BOTT_LAY , A.ACCO_LEVEL , \n\t\tA.ACC_SUB , DECODE(A.IS_BOTT_LAY, 1, 0, 1) ISKMDATA, A.IS_STOPED , \n\t\t0 SUMMARY, B.FINA_ORG , B.SUPE_COMP_ID SUPE_MAN_COMP_ID, \n\t\tB.FINA_ORG_NM , B.IS_BOTT_LAY COMPLEAF\n\tFROM\n\t\tACC_SUBJECT_EXT A, ACC_COMP_SCENE B\n\tWHERE\n\t\tA.ACC_BOOK = {3}\n\t\tAND A.FISC_YEA = {4} AND A.FINA_ORG = {5} {1}\n\t\tAND A.ACCO_LEVEL <= {2}\n\t\tAND A.ITEM_CODE IN ( SELECT ITEMCODE FROM GT_KMDESTTAB GROUP BY ITEMCODE)\n\t\tAND B.ORG_SCE_ID = ( SELECT ORG_SCE_ID FROM ACC_BOOK WHERE ACC_BOOK = {3} )\n\t\tAND B.FINA_ORG = {6}\n\t\tAND B.FISC_YEA = {4}) A\nLEFT JOIN ACC_QT_DIM_VOU_DTL b ON\n\tB.ITEM_CODE = a.ITEM_CODE AND B.KEY_VALUE = {7}) A";

    private AccComprehensiveQueryDaoConst() {
    }

    static {
        DATATYPE_ENUM.put("ALL", "");
        DATATYPE_ENUM.put("ACCRUALISNOTZERO", " ABS(A.CR_AMT_TOT) + ABS(A.DR_AMT_TOT) >0 ");
        DATATYPE_ENUM.put("BALANCEISNOTZERO", " ABS(A.CR_BALP_E- A.DR_BALP_E) + ABS(A.CR_BALP_S-A.DR_BALP_S) > 0 ");
        DATATYPE_ENUM.put("ACCRUALANDBALANCEISZERO", "  ABS(A.CR_AMT_TOT) + ABS(A.DR_AMT_TOT) + ABS(A.CR_BALP_E- A.DR_BALP_E) >0 ");
        DATATYPE_ENUM.put("ACCRUALANDBALANCEISNOTZERO", " ABS(A.CR_AMT_TOT) + ABS(A.DR_AMT_TOT) > 0  AND  ABS(A.CR_BALP_E- A.DR_BALP_E) + ABS(A.CR_BALP_S-A.DR_BALP_S) >0  ");
        DATATYPE_ENUM.put("ANNUALCUMULATIVEISNOTZERO", "  ABS(A.DR_AMT_Y) + ABS(A.CR_AMT_Y) + ABS(A.CR_BALP_E- A.DR_BALP_E) >0 ");
        DATATYPE_ENUM_KM = new HashMap();
        DATATYPE_ENUM_KM.put("ALL", "");
        DATATYPE_ENUM_KM.put("ACCRUALISNOTZERO", " ABS(A.SUM_J_BWB) + ABS(A.SUM_D_BWB) >0 ");
        DATATYPE_ENUM_KM.put("BALANCEISNOTZERO", " ABS(A.QCYE_BWB) + ABS(A.QMYE_BWB) > 0 ");
        DATATYPE_ENUM_KM.put("ACCRUALANDBALANCEISZERO", "  ABS(A.SUM_J_BWB) + ABS(A.SUM_D_BWB) + ABS(A.QCYE_BWB) +  ABS(A.QMYE_BWB) >0 ");
        DATATYPE_ENUM_KM.put("ACCRUALANDBALANCEISNOTZERO", " ABS(A.SUM_J_BWB) + ABS(A.SUM_D_BWB) > 0  AND  ABS(A.QCYE_BWB) + ABS(A.QMYE_BWB) > 0 ");
        DATATYPE_ENUM_KM.put("ANNUALCUMULATIVEISNOTZERO", "  ABS(A.SUM_JL_BWB) + ABS(A.SUM_DL_BWB) + ABS(A.QCYE_BWB) +  ABS(A.QMYE_BWB) >0 ");
        DATATYPE_ENUM_SUM = new HashMap();
        DATATYPE_ENUM_SUM.put("ALL", "");
        DATATYPE_ENUM_SUM.put("ACCRUALISNOTZERO", " HAVING ABS(SUM(B.SUM_J)) + ABS(SUM(B.SUM_D)) >0 ");
        DATATYPE_ENUM_SUM.put("BALANCEISNOTZERO", " HAVING ABS(SUM(B.QCYE_BWB)) + ABS(SUM(B.QMYE_BWB)) > 0 ");
        DATATYPE_ENUM_SUM.put("ACCRUALANDBALANCEISZERO", "  HAVING ABS(SUM(B.SUM_J)) + ABS(SUM(B.SUM_D)) + ABS(SUM(B.QCYE_BWB)) +  ABS(SUM(B.QMYE_BWB)) >0 ");
        DATATYPE_ENUM_SUM.put("ACCRUALANDBALANCEISNOTZERO", " HAVING ABS(SUM(B.SUM_J)) + ABS(SUM(B.SUM_D)) > 0  AND  ABS(SUM(B.QCYE_BWB)) + ABS(SUM(B.QMYE_BWB)) > 0 ");
        DATATYPE_ENUM_SUM.put("ANNUALCUMULATIVEISNOTZERO", "  HAVING ABS(SUM(B.SUM_JL)) + ABS(SUM(B.SUM_DL)) + ABS(SUM(B.QCYE_BWB)) +  ABS(SUM(B.QMYE_BWB)) >0 ");
        DATATYPE_ENUM_KM_FOR_WD = new HashMap();
        DATATYPE_ENUM_KM_FOR_WD.put("ALL", "");
        DATATYPE_ENUM_KM_FOR_WD.put("ACCRUALISNOTZERO", " ABS(SUM(A.SUM_J_BWB)) + ABS(SUM(A.SUM_D_BWB)) >0 ");
        DATATYPE_ENUM_KM_FOR_WD.put("BALANCEISNOTZERO", " ABS(SUM(A.QCYE_BWB)) + ABS(SUM(A.QMYE_BWB)) > 0 ");
        DATATYPE_ENUM_KM_FOR_WD.put("ACCRUALANDBALANCEISZERO", "  ABS(SUM(A.SUM_J_BWB)) + ABS(SUM(A.SUM_D_BWB)) + ABS(SUM(A.QCYE_BWB)) +  ABS(SUM(A.QMYE_BWB)) >0 ");
        DATATYPE_ENUM_KM_FOR_WD.put("ACCRUALANDBALANCEISNOTZERO", " ABS(SUM(A.SUM_J_BWB)) + ABS(SUM(A.SUM_D_BWB)) > 0  AND  ABS(SUM(A.QCYE_BWB)) + ABS(SUM(A.QMYE_BWB)) > 0 ");
        DATATYPE_ENUM_KM_FOR_WD.put("ANNUALCUMULATIVEISNOTZERO", "  ABS(SUM(A.SUM_JL_BWB)) + ABS(SUM(A.SUM_DL_BWB)) + ABS(SUM(A.QCYE_BWB)) +  ABS(SUM(A.QMYE_BWB)) >0 ");
        SQL_GET_ENDACCOUNT_ENDTIME = SqlResource.getSql(SQL_CLASS, "SQL_GET_ENDACCOUNT_ENDTIME", new String[0]);
        SQL_GET_ACCOUNT_RANGE = SqlResource.getSql(SQL_CLASS, "SQL_GET_ACCOUNT_RANGE", new String[0]);
        SQL_QUERY_GETWDDY = SqlResource.getSql(SQL_CLASS, "SQL_QUERY_GETWDDY", new String[0]);
        SQL_QUERY_GETXTSSZDS = SqlResource.getSql(SQL_CLASS, "SQL_QUERY_GETXTSSZDS", new String[0]);
        SQL_QUERY_GETXTSSZD = SqlResource.getSql(SQL_CLASS, "SQL_QUERY_GETXTSSZD", new String[0]);
        FIND_KM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_KM_HZ_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_HZ_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_KM_HZ_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_HZ_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_KM_HZ_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_HZ_INFO_FOR_MONTH", new String[0]);
        FIND_KM_HZ_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_HZ_INFO_BY_MONTH", new String[0]);
        FIND_KM_HZ_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_HZ_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_KM_HZ_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_KM_HZ_INFO_BY_QUARTER", new String[0]);
        FIND_KM_HZ_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_HZ_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        FIND_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_ONE_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_DIM_HZ_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HZ_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_ONE_DIM_HZ_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HZ_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_DIM_HZ_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HZ_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_ONE_DIM_HZ_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HZ_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_DIM_HZ_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HZ_INFO_FOR_MONTH", new String[0]);
        FIND_ONE_DIM_HZ_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HZ_INFO_FOR_MONTH", new String[0]);
        FIND_DIM_HZ_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HZ_INFO_BY_MONTH", new String[0]);
        FIND_ONE_DIM_HZ_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HZ_INFO_BY_MONTH", new String[0]);
        FIND_DIM_HZ_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HZ_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_ONE_DIM_HZ_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HZ_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_DIM_HZ_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HZ_INFO_BY_QUARTER", new String[0]);
        FIND_ONE_DIM_HZ_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HZ_INFO_BY_QUARTER", new String[0]);
        FIND_DIM_HZ_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HZ_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        FIND_ONE_DIM_HZ_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HZ_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        FIND_KM_HB_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_HB_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_KM_HB_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_HB_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_KM_HB_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_HB_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_KM_HB_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_HB_INFO_FOR_MONTH", new String[0]);
        FIND_KM_HB_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_HB_INFO_BY_MONTH", new String[0]);
        FIND_KM_HB_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_HB_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_KM_HB_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_KM_HB_INFO_BY_QUARTER", new String[0]);
        FIND_KM_HB_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_HB_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        FIND_DIM_HB_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HB_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_DIM_HB_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HB_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_DIM_HB_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HB_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_DIM_HB_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HB_INFO_FOR_MONTH", new String[0]);
        FIND_DIM_HB_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HB_INFO_BY_MONTH", new String[0]);
        FIND_DIM_HB_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HB_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_DIM_HB_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HB_INFO_BY_QUARTER", new String[0]);
        FIND_DIM_HB_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_HB_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        FIND_ONE_DIM_HB_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HB_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_ONE_DIM_HB_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HB_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_ONE_DIM_HB_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HB_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_ONE_DIM_HB_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HB_INFO_FOR_MONTH", new String[0]);
        FIND_ONE_DIM_HB_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HB_INFO_BY_MONTH", new String[0]);
        FIND_ONE_DIM_HB_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HB_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_ONE_DIM_HB_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HB_INFO_BY_QUARTER", new String[0]);
        FIND_ONE_DIM_HB_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_HB_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        FIND_KM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_KM_OSET_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_OSET_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_KM_OSET_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_OSET_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_KM_OSET_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_OSET_INFO_FOR_MONTH", new String[0]);
        FIND_KM_OSET_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_OSET_INFO_BY_MONTH", new String[0]);
        FIND_KM_OSET_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_OSET_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_KM_OSET_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_KM_OSET_INFO_BY_QUARTER", new String[0]);
        FIND_KM_OSET_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_OSET_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        FIND_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_DIM_OSET_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_DIM_OSET_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_DIM_OSET_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_OSET_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_DIM_OSET_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_DIM_OSET_INFO_FOR_MONTH", new String[0]);
        FIND_DIM_OSET_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_DIM_OSET_INFO_BY_MONTH", new String[0]);
        FIND_DIM_OSET_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_OSET_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_DIM_OSET_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_DIM_OSET_INFO_BY_QUARTER", new String[0]);
        FIND_DIM_OSET_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_DIM_OSET_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        FIND_ONE_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_ONE_DIM_OSET_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_OSET_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_ONE_DIM_OSET_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_OSET_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_ONE_DIM_OSET_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_OSET_INFO_FOR_MONTH", new String[0]);
        FIND_ONE_DIM_OSET_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_OSET_INFO_BY_MONTH", new String[0]);
        FIND_ONE_DIM_OSET_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_OSET_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_ONE_DIM_OSET_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_OSET_INFO_BY_QUARTER", new String[0]);
        FIND_ONE_DIM_OSET_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_ONE_DIM_OSET_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM_CLS = SqlResource.getSql(SQL_CLASS, "COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM_CLS", new String[0]);
        COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM_CLS_FOR_CUR = SqlResource.getSql(SQL_CLASS, "COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM_CLS_FOR_CUR", new String[0]);
        COL_FOR_ROW_HZ_TEMP_CQUERY = SqlResource.getSql(SQL_CLASS, "COL_FOR_ROW_HZ_TEMP_CQUERY", new String[0]);
        COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM = SqlResource.getSql(SQL_CLASS, "COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM", new String[0]);
        COL_FOR_ROW_HZ_TEMP_CQUERY_FOR_CUR = SqlResource.getSql(SQL_CLASS, "COL_FOR_ROW_HZ_TEMP_CQUERY_FOR_CUR", new String[0]);
        COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM_FOR_CUR = SqlResource.getSql(SQL_CLASS, "COL_FOR_ROW_HZ_TEMP_CQUERY_ONE_DIM_FOR_CUR", new String[0]);
        NOCOL_FOR_ROW_HZ_TEMP_CQUERY = SqlResource.getSql(SQL_CLASS, "NOCOL_FOR_ROW_HZ_TEMP_CQUERY", new String[0]);
        NOCOL_FOR_ROW_HZ_TEMP_CQUERY_FOR_CUR = SqlResource.getSql(SQL_CLASS, "NOCOL_FOR_ROW_HZ_TEMP_CQUERY_FOR_CUR", new String[0]);
        INSERT_RESULT_IN_HZ_TEMP_ONE_DIM = SqlResource.getSql(SQL_CLASS, "INSERT_RESULT_IN_HZ_TEMP_ONE_DIM", new String[0]);
        INSERT_RESULT_IN_HZ_TEMP_ONE_DIM_FOR_CUR = SqlResource.getSql(SQL_CLASS, "INSERT_RESULT_IN_HZ_TEMP_ONE_DIM_FOR_CUR", new String[0]);
        FIND_KM_SHOW_DIM_INFO = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_DIM_INFO", new String[0]);
        FIND_COMP_P_COMP_ID = SqlResource.getSql(SQL_CLASS, "FIND_COMP_P_COMP_ID", new String[0]);
        FIND_BOTTOM_COMP = SqlResource.getSql(SQL_CLASS, "FIND_BOTTOM_COMP", new String[0]);
        DW_KM_HZ_TREE_QUERY = SqlResource.getSql(SQL_CLASS, "DW_KM_HZ_TREE_QUERY", new String[0]);
        DW_KM_HZ_TREE_QUERY_FOR_CUR = SqlResource.getSql(SQL_CLASS, "DW_KM_HZ_TREE_QUERY_FOR_CUR", new String[0]);
        DW_KM_HZ_TREE_QUERY_NO_DIM = SqlResource.getSql(SQL_CLASS, "DW_KM_HZ_TREE_QUERY_NO_DIM", new String[0]);
        DW_KM_HZ_TREE_QUERY_FOR_CUR_NO_DIM = SqlResource.getSql(SQL_CLASS, "DW_KM_HZ_TREE_QUERY_FOR_CUR_NO_DIM", new String[0]);
        DW_KM_HZ_TREE_QUERY_ONLY_DIM = SqlResource.getSql(SQL_CLASS, "DW_KM_HZ_TREE_QUERY_ONLY_DIM", new String[0]);
        DW_KM_HZ_TREE_QUERY_ONLY_DIM_FOR_CUR = SqlResource.getSql(SQL_CLASS, "DW_KM_HZ_TREE_QUERY_ONLY_DIM_FOR_CUR", new String[0]);
        DW_KM_OBJECT_HZ_TREE_QUERY = SqlResource.getSql(SQL_CLASS, "DW_KM_OBJECT_HZ_TREE_QUERY", new String[0]);
        DW_KM_OBJECT_HZ_TREE_QUERY_FOR_CUR = SqlResource.getSql(SQL_CLASS, "DW_KM_OBJECT_HZ_TREE_QUERY_FOR_CUR", new String[0]);
        DW_KM_BUS_CLASS_HZ_TREE_QUERY = SqlResource.getSql(SQL_CLASS, "DW_KM_BUS_CLASS_HZ_TREE_QUERY", new String[0]);
        DW_KM_BUS_CLASS_HZ_TREE_QUERY_FOR_CUR = SqlResource.getSql(SQL_CLASS, "DW_KM_BUS_CLASS_HZ_TREE_QUERY_FOR_CUR", new String[0]);
        QUERY_RESULT_INTO_QT_TABLE = SqlResource.getSql(SQL_CLASS, "QUERY_RESULT_INTO_QT_TABLE", new String[0]);
        QUERY_RESULT_INTO_QT_TABLE_FOR_CUR = SqlResource.getSql(SQL_CLASS, "QUERY_RESULT_INTO_QT_TABLE_FOR_CUR", new String[0]);
        QUERY_RESULT_FROM_QT_TABLE = SqlResource.getSql(SQL_CLASS, "QUERY_RESULT_FROM_QT_TABLE", new String[0]);
        QUERY_RESULT_FROM_QT_TABLE_FOR_CUR = SqlResource.getSql(SQL_CLASS, "QUERY_RESULT_FROM_QT_TABLE_FOR_CUR", new String[0]);
        SQL_LIST_YWFL_ID_NAME = SqlResource.getSql(SQL_CLASS, "SQL_LIST_YWFL_ID_NAME", new String[0]);
        SQL_LIST_KM_ID_BY_ITEM_CODE = SqlResource.getSql(SQL_CLASS, "SQL_LIST_KM_ID_BY_ITEM_CODE", new String[0]);
        BUILD_KM_TREE = SqlResource.getSql(SQL_CLASS, "BUILD_KM_TREE", new String[0]);
        BUILD_ACCOUNT_ID = SqlResource.getSql(SQL_CLASS, "BUILD_ACCOUNT_ID", new String[0]);
        RETUEN_ACCOUNT_ID = SqlResource.getSql(SQL_CLASS, "RETUEN_ACCOUNT_ID", new String[0]);
        RETUEN_MONEY_TYPE = SqlResource.getSql(SQL_CLASS, "RETUEN_MONEY_TYPE", new String[0]);
        RETUEN_MONEY_TYPE_FOR_CUR = SqlResource.getSql(SQL_CLASS, "RETUEN_MONEY_TYPE_FOR_CUR", new String[0]);
        BUILD_KM_LEAF_FOR_DIM = SqlResource.getSql(SQL_CLASS, "BUILD_KM_LEAF_FOR_DIM", new String[0]);
        RETUEN_ACCOUNT_ID_MONEY_TYPE = SqlResource.getSql(SQL_CLASS, "RETUEN_ACCOUNT_ID_MONEY_TYPE", new String[0]);
        BUILD_COMP = SqlResource.getSql(SQL_CLASS, "BUILD_COMP", new String[0]);
        RETURN_COMP = SqlResource.getSql(SQL_CLASS, "RETURN_COMP", new String[0]);
        RETURN_COMP_MONEY_TYPE = SqlResource.getSql(SQL_CLASS, "RETURN_COMP_MONEY_TYPE", new String[0]);
        RETURN_COMP_ACCOUNT_MONEY_TYPE = SqlResource.getSql(SQL_CLASS, "RETURN_COMP_ACCOUNT_MONEY_TYPE", new String[0]);
        RETURN_COMP_ACCOUNT = SqlResource.getSql(SQL_CLASS, "RETURN_COMP_ACCOUNT", new String[0]);
        BUILD_COMP_ACCOUNT = SqlResource.getSql(SQL_CLASS, "BUILD_COMP_ACCOUNT", new String[0]);
        BUILD_KM_LEAF = SqlResource.getSql(SQL_CLASS, "BUILD_KM_LEAF", new String[0]);
        RETURN_KM_LEAF = SqlResource.getSql(SQL_CLASS, "RETURN_KM_LEAF", new String[0]);
        BUILD_KM_LEAF_ACCOUNT = SqlResource.getSql(SQL_CLASS, "BUILD_KM_LEAF_ACCOUNT", new String[0]);
        RETURN_KM_LEAF_ACCOUNT = SqlResource.getSql(SQL_CLASS, "RETURN_KM_LEAF_ACCOUNT", new String[0]);
        BUILD_KM_LEAF_COMP_ACCOUNT = SqlResource.getSql(SQL_CLASS, "BUILD_KM_LEAF_COMP_ACCOUNT", new String[0]);
        RETURN_KM_LEAF_COMP_ACCOUNT = SqlResource.getSql(SQL_CLASS, "RETURN_KM_LEAF_COMP_ACCOUNT", new String[0]);
        BUILD_KM_LEAF_COMP = SqlResource.getSql(SQL_CLASS, "BUILD_KM_LEAF_COMP", new String[0]);
        RETURN_KM_LEAF_COMP = SqlResource.getSql(SQL_CLASS, "RETURN_KM_LEAF_COMP", new String[0]);
        BUILD_COMP_EXPORT = SqlResource.getSql(SQL_CLASS, "BUILD_COMP_EXPORT", new String[0]);
        RETURN_COMP_EXPORT = SqlResource.getSql(SQL_CLASS, "RETURN_COMP_EXPORT", new String[0]);
        RETURN_COMP_MONEY_TYPE_EXPORT = SqlResource.getSql(SQL_CLASS, "RETURN_COMP_MONEY_TYPE_EXPORT", new String[0]);
        BUILD_COMP_ACCOUNT_EXPORT = SqlResource.getSql(SQL_CLASS, "BUILD_COMP_ACCOUNT_EXPORT", new String[0]);
        RETURN_COMP_ACCOUNT_EXPORT = SqlResource.getSql(SQL_CLASS, "RETURN_COMP_ACCOUNT_EXPORT", new String[0]);
        RETURN_COMP_ACCOUNT_MONEY_TYPE_EXPORT = SqlResource.getSql(SQL_CLASS, "RETURN_COMP_ACCOUNT_MONEY_TYPE_EXPORT", new String[0]);
        BUILD_KM_LEAF_COMP_EXPORT = SqlResource.getSql(SQL_CLASS, "BUILD_KM_LEAF_COMP_EXPORT", new String[0]);
        BUILD_KM_LEAF_COMP_ACCOUNT_EXPORT = SqlResource.getSql(SQL_CLASS, "BUILD_KM_LEAF_COMP_ACCOUNT_EXPORT", new String[0]);
        DW_FL_TREE_RELATION = SqlResource.getSql(SQL_CLASS, "DW_FL_TREE_RELATION", new String[0]);
        FL_FIND_ITEMCODE = SqlResource.getSql(SQL_CLASS, "FL_FIND_ITEMCODE", new String[0]);
        SQL_INS_COMPS_QUERY = SqlResource.getSql(SQL_CLASS, "SQL_INS_COMPS_QUERY", new String[0]);
        SQL_LIST_YWFL_ITEMCODE_NAME = SqlResource.getSql(SQL_CLASS, "SQL_LIST_YWFL_ITEMCODE_NAME", new String[0]);
        SQL_LIST_YWFL_ITEMCODE = SqlResource.getSql(SQL_CLASS, "SQL_LIST_YWFL_ITEMCODE", new String[0]);
        SQL_LIST_DXFL_ID_NAME = SqlResource.getSql(SQL_CLASS, "SQL_LIST_DXFL_ID_NAME", new String[0]);
        SQL_LIST_ENUM_ID_NAME = SqlResource.getSql(SQL_CLASS, "SQL_LIST_ENUM_ID_NAME", new String[0]);
        SQL_LIST_KM_ID_NAME = SqlResource.getSql(SQL_CLASS, "SQL_LIST_KM_ID_NAME", new String[0]);
        SQL_DO_NOT_BLANK_WD = SqlResource.getSql(SQL_CLASS, "SQL_DO_NOT_BLANK_WD", new String[0]);
        SQL_GET_NOT_BLANK_WD = SqlResource.getSql(SQL_CLASS, "SQL_GET_NOT_BLANK_WD", new String[0]);
        GET_ANALYZECOMPANYINFO_SQL_DEFAULT = SqlResource.getSql(SQL_CLASS, "GET_ANALYZECOMPANYINFO_SQL_DEFAULT", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH_FOR_CUR_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH_FOR_CUR_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH_FOR_CUR_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH_FOR_CUR_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER_FOR_CUR_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER_FOR_CUR_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH_FOR_CUR_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH_FOR_CUR_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH_FOR_CUR_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH_FOR_CUR_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER_FOR_CUR_SHOW_EMPTY = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER_FOR_CUR_SHOW_EMPTY", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_FOR_MONTH", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER", new String[0]);
        FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_HZ_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH_FOR_CUR", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_ONE_MONTH", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH_FOR_CUR", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_FOR_MONTH", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_MONTH_FOR_CUR", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER", new String[0]);
        FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER_FOR_CUR = SqlResource.getSql(SQL_CLASS, "FIND_KM_SHOW_ALL_DIM_OSET_INFO_BY_QUARTER_FOR_CUR", new String[0]);
        SHOW_ALL_DIM_FOR_TEMP_CQUERY = SqlResource.getSql(SQL_CLASS, "SHOW_ALL_DIM_FOR_TEMP_CQUERY", new String[0]);
        SHOW_ALL_DIM_FOR_TEMP_CQUERY_FOR_CUR = SqlResource.getSql(SQL_CLASS, "SHOW_ALL_DIM_FOR_TEMP_CQUERY_FOR_CUR", new String[0]);
        FIND_DIM_FROM_DIM_GROUP = SqlResource.getSql(SQL_CLASS, "FIND_DIM_FROM_DIM_GROUP", new String[0]);
        SHOW_ALL_DIM_FOR_COL = SqlResource.getSql(SQL_CLASS, "SHOW_ALL_DIM_FOR_COL", new String[0]);
        SHOW_ALL_DIM_INTO_TEMP = SqlResource.getSql(SQL_CLASS, "SHOW_ALL_DIM_INTO_TEMP", new String[0]);
        SHOW_ALL_DIM_INTO_TEMP_FOR_CUR = SqlResource.getSql(SQL_CLASS, "SHOW_ALL_DIM_INTO_TEMP_FOR_CUR", new String[0]);
        DELETE_SHOW_ALL_DIM_BZXZ_0 = SqlResource.getSql(SQL_CLASS, "DELETE_SHOW_ALL_DIM_BZXZ_0", new String[0]);
        MER_JAN_DATA_TO_GT_ZW_WDBILLMX = SqlResource.getSql(SQL_CLASS, "MER_JAN_DATA_TO_GT_ZW_WDBILLMX", new String[0]);
        YW_MAIN_DATA_GROUP_TO_GT_ZW_WDBILLMX2 = SqlResource.getSql(SQL_CLASS, "YW_MAIN_DATA_GROUP_TO_GT_ZW_WDBILLMX2", new String[0]);
        INSERT_YW_MAIN_DATA_GROUP_TO_GT_ZW_WDBILLMX = SqlResource.getSql(SQL_CLASS, "INSERT_YW_MAIN_DATA_GROUP_TO_GT_ZW_WDBILLMX", new String[0]);
        OPEN_LOG = SqlResource.getSql(SQL_CLASS, "OPEN_LOG", new String[0]);
        CLOSE_LOG = SqlResource.getSql(SQL_CLASS, "CLOSE_LOG", new String[0]);
        CLEAR_LOG = SqlResource.getSql(SQL_CLASS, "CLEAR_LOG", new String[0]);
        FIND_LOG = SqlResource.getSql(SQL_CLASS, "FIND_LOG", new String[0]);
        INSERT_ALLKM = SqlResource.getSql(SQL_CLASS, "INSERT_ALLKM", new String[0]);
        QUERY_KM = SqlResource.getSql(SQL_CLASS, "QUERY_KM", new String[0]);
    }
}
